You can use the filters at the top of the screen to filter the results in the Validation Rulesets panel.

The filter fields are described in the following table.

Do one of the following:

• Select the relevant options from the drop-downs, and then click the Find button

  

• Click the Clear button to reset the drop-downs to their default state

  

The filter is then applied to the results in the Validation Rulesets panel.

You can also use the search bar in the Validation Rulesets panel to locate a specific ruleset.

Use the Admin Commands ribbon to manage your validation rulesets.

The buttons in the Admin Commands ribbon are described in the following table.

To add or edit a ruleset:

1. Click the Add button on the Admin Commands ribbon.

   

   Alternatively, select an existing ruleset from the Validation Rulesets panel.

   

2. Enter or edit the details in the Validation panel.

   

   Statutory rulesets cannot be edited, but can be made active or inactive with the Validation Superuser role.

The fields in the Validation panel are described in the following table.

3. Click Save.

Use the Validation Rule Editor to create a simple rule for your validation ruleset.

You cannot edit statutory rules.

To add or edit a simple rule:

1. Select the relevant ruleset in the Validation Rulesets panel, and then click the Manage Rules button on the Admin Commands ribbon.

   

   The Validation Rule Editor is displayed.

   

   If a complex rule has already been created, you cannot create a simple rule as the Simple Rule tab is disabled.

   If you are creating a new rule, the All child conditions must be satisfied (AND) logical group is displayed by default. This grouping cannot be removed.

   

2. Do one of the following:

   • Add a grouping

     1. Click the Add button where you want to add the grouping, and then select Add Validation Rule Grouping from the drop-down list.

        

     2. The All child conditions must be satisfied (AND) grouping is added, which means all child comparisons that you want to add must be satisfied.

        Select Any child condition can be satisfied (OR) from the drop-down list if any of the child comparisons you want to add can be satisfied.

        

   • Add a comparison

     1. Click the Add button where you want to add the comparison, and then select Add Column Comparison To Value or Add Column Comparison To Another Column from the drop-down list.

        

        The comparison is added to the specified location.

        

        Fields are case sensitive.

     2. Select or enter the required values from the three fields that are displayed.

        If the is null or is not null operators are selected, the third field is removed.

        

        If the 'Add Column Comparison To Another Column' option was selected, the value types (signified by 'N' for numeric, 'D' for date and 'S' for string) in the first and third fields must match.

        

   • Remove a comparison or grouping - click the Delete button adjacent to the relevant comparison or group to remove it

     The top-level group cannot be removed.

     

3. Enter an error message to display in the Error Message field.
4. Click Save.

After creating a simple rule, you can use the Complex Rule tab to create a more complex rule for your validation ruleset by using C#.

You cannot edit statutory rules.

To add or edit a complex rule:

1. Select the relevant ruleset in the Validation Rulesets panel, and then click the Manage Rules button on the Admin Commands ribbon.

   

   The Validation Rule Editor is displayed.

   You cannot edit using the Simple Rule tab after saving changes in the Complex Rule tab.

   

   If a complex rule has already been created, the Complex Rule tab is displayed by default.

2. Click the Complex Rule tab.

   

   A confirmation message is displayed.

   

3. Click OK.

   The Complex Rule tab is displayed.

   

4. Edit the relevant C# code as required.

   Values are case sensitive.

   Any errors in the code are displayed in the Rule Errors panel.

   

   You cannot save the rule if errors exist.

5. Click Save.

You can use Validation Manager to view statutory ruleset information.

To view statutory rulesets:

1. Select 'Statutory' from the Scope: drop-down list.

   

2. Click the Find button.

   

   Statutory rulesets are listed in the Validation Rulesets panel. Select the relevant rule to display a summary of the ruleset in the Validation panel.

   

   Click the Manage Rules button to open the Validation Rule Editor where you can view, but not edit, simple and complex ruleset information for the selected rule.

   

Statutory rules are read-only. You cannot create new statutory rulesets or edit existing rules.